﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using Supersense.db;
using System.Data;

public partial class solution_detail : System.Web.UI.Page
{
    public DataTable industry;
    public DataTable stardand;
    public DataTable relationProduct;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        Crud modelSolution = new Crud("ss_spacenews","id");
        int id = Convert.ToInt32(Request.QueryString["type"]);


        Crud modelCategory = new Crud("ss_category","id");

        DataTable dt = modelCategory.fPk(id);
        detail_repeater.DataSource = dt;
        detail_repeater.DataBind();
        industry = modelCategory.fList("type='industry'", "", "", "");


        Crud modelStardand = new Crud("ss_industry_ext1", "id");
        stardand = modelStardand.fList("industry_id=" + Convert.ToInt32(Request.QueryString["type"]), "", "", "");

        string sql = "SELECT * FROM ss_product where id in(select product_id from ss_industry_ext where industry_id =" + Convert.ToInt32(Request.QueryString["type"]) + " )";
        Database modelProduct = new Database();
        relationProduct = modelProduct.executedt(sql);
        
    }
}